﻿IF object_id(N'dbo.UDS_Task_Subscription', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[UDS_Task_Subscription] (
        [ID]            int         NOT NULL identity(1, 1),
        [TaskID]        int         NOT NULL,
        [Username]      nvarchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
        [ExUsername]    nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
        [Date]          datetime    NOT NULL,
        [SubscribeDate] datetime    NULL CONSTRAINT [DF_UDS_Task_Subscription_SubscribeDate] default((getdate())),

        CONSTRAINT [PK_UDS_Task_Subscribe] PRIMARY KEY CLUSTERED ([ID] asc)
    );
END
GO
